﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ReportDataSet" targetNamespace="http://tempuri.org/ReportDataSet.xsd" xmlns:mstns="http://tempuri.org/ReportDataSet.xsd" xmlns="http://tempuri.org/ReportDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RISConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RISConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ViewLayer.Properties.Settings.GlobalReference.Default.RISConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Procedure_TableAdapter" GeneratorDataComponentClassName="Procedure_TableAdapter" Name="Procedure_" UserDataComponentName="Procedure_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.Procedure_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Procedure_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([OrderOID_] = @Original_OrderOID_) AND ([ProcedureTypeOID_] = @Original_ProcedureTypeOID_) AND ([Index_] = @Original_Index_) AND ((@IsNull_ScheduledStartTime_ = 1 AND [ScheduledStartTime_] IS NULL) OR ([ScheduledStartTime_] = @Original_ScheduledStartTime_)) AND ((@IsNull_StartTime_ = 1 AND [StartTime_] IS NULL) OR ([StartTime_] = @Original_StartTime_)) AND ((@IsNull_EndTime_ = 1 AND [EndTime_] IS NULL) OR ([EndTime_] = @Original_EndTime_)) AND ([Status_] = @Original_Status_) AND ((@IsNull_PerformingFacilityOID_ = 1 AND [PerformingFacilityOID_] IS NULL) OR ([PerformingFacilityOID_] = @Original_PerformingFacilityOID_)) AND ([Laterality_] = @Original_Laterality_) AND ((@IsNull_Portable_ = 1 AND [Portable_] IS NULL) OR ([Portable_] = @Original_Portable_)) AND ((@IsNull_ProcedureCheckInOID_ = 1 AND [ProcedureCheckInOID_] IS NULL) OR ([ProcedureCheckInOID_] = @Original_ProcedureCheckInOID_)) AND ((@IsNull_ImageAvailability_ = 1 AND [ImageAvailability_] IS NULL) OR ([ImageAvailability_] = @Original_ImageAvailability_)) AND ([DowntimeRecoveryMode_] = @Original_DowntimeRecoveryMode_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OrderOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OrderOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProcedureTypeOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureTypeOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Index_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Index_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScheduledStartTime_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScheduledStartTime_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ScheduledStartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ScheduledStartTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartTime_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartTime_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndTime_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndTime_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PerformingFacilityOID_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PerformingFacilityOID_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PerformingFacilityOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PerformingFacilityOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Laterality_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Laterality_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Portable_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Portable_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Portable_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Portable_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProcedureCheckInOID_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProcedureCheckInOID_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProcedureCheckInOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureCheckInOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImageAvailability_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImageAvailability_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ImageAvailability_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImageAvailability_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DowntimeRecoveryMode_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DowntimeRecoveryMode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Procedure_] ([OID_], [Version_], [OrderOID_], [ProcedureTypeOID_], [Index_], [ScheduledStartTime_], [StartTime_], [EndTime_], [Status_], [PerformingFacilityOID_], [Laterality_], [Portable_], [ProcedureCheckInOID_], [ImageAvailability_], [DowntimeRecoveryMode_]) VALUES (@OID_, @Version_, @OrderOID_, @ProcedureTypeOID_, @Index_, @ScheduledStartTime_, @StartTime_, @EndTime_, @Status_, @PerformingFacilityOID_, @Laterality_, @Portable_, @ProcedureCheckInOID_, @ImageAvailability_, @DowntimeRecoveryMode_);
SELECT OID_, Version_, OrderOID_, ProcedureTypeOID_, Index_, ScheduledStartTime_, StartTime_, EndTime_, Status_, PerformingFacilityOID_, Laterality_, Portable_, ProcedureCheckInOID_, ImageAvailability_, DowntimeRecoveryMode_ FROM Procedure_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OrderOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OrderOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProcedureTypeOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureTypeOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Index_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Index_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ScheduledStartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ScheduledStartTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PerformingFacilityOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PerformingFacilityOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Laterality_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Laterality_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Portable_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Portable_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProcedureCheckInOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureCheckInOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ImageAvailability_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImageAvailability_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DowntimeRecoveryMode_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DowntimeRecoveryMode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OID_, Version_, OrderOID_, ProcedureTypeOID_, Index_, ScheduledStartTime_, StartTime_, EndTime_, Status_, PerformingFacilityOID_, Laterality_, Portable_, ProcedureCheckInOID_, ImageAvailability_, DowntimeRecoveryMode_ FROM dbo.Procedure_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Procedure_] SET [OID_] = @OID_, [Version_] = @Version_, [OrderOID_] = @OrderOID_, [ProcedureTypeOID_] = @ProcedureTypeOID_, [Index_] = @Index_, [ScheduledStartTime_] = @ScheduledStartTime_, [StartTime_] = @StartTime_, [EndTime_] = @EndTime_, [Status_] = @Status_, [PerformingFacilityOID_] = @PerformingFacilityOID_, [Laterality_] = @Laterality_, [Portable_] = @Portable_, [ProcedureCheckInOID_] = @ProcedureCheckInOID_, [ImageAvailability_] = @ImageAvailability_, [DowntimeRecoveryMode_] = @DowntimeRecoveryMode_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([OrderOID_] = @Original_OrderOID_) AND ([ProcedureTypeOID_] = @Original_ProcedureTypeOID_) AND ([Index_] = @Original_Index_) AND ((@IsNull_ScheduledStartTime_ = 1 AND [ScheduledStartTime_] IS NULL) OR ([ScheduledStartTime_] = @Original_ScheduledStartTime_)) AND ((@IsNull_StartTime_ = 1 AND [StartTime_] IS NULL) OR ([StartTime_] = @Original_StartTime_)) AND ((@IsNull_EndTime_ = 1 AND [EndTime_] IS NULL) OR ([EndTime_] = @Original_EndTime_)) AND ([Status_] = @Original_Status_) AND ((@IsNull_PerformingFacilityOID_ = 1 AND [PerformingFacilityOID_] IS NULL) OR ([PerformingFacilityOID_] = @Original_PerformingFacilityOID_)) AND ([Laterality_] = @Original_Laterality_) AND ((@IsNull_Portable_ = 1 AND [Portable_] IS NULL) OR ([Portable_] = @Original_Portable_)) AND ((@IsNull_ProcedureCheckInOID_ = 1 AND [ProcedureCheckInOID_] IS NULL) OR ([ProcedureCheckInOID_] = @Original_ProcedureCheckInOID_)) AND ((@IsNull_ImageAvailability_ = 1 AND [ImageAvailability_] IS NULL) OR ([ImageAvailability_] = @Original_ImageAvailability_)) AND ([DowntimeRecoveryMode_] = @Original_DowntimeRecoveryMode_));
SELECT OID_, Version_, OrderOID_, ProcedureTypeOID_, Index_, ScheduledStartTime_, StartTime_, EndTime_, Status_, PerformingFacilityOID_, Laterality_, Portable_, ProcedureCheckInOID_, ImageAvailability_, DowntimeRecoveryMode_ FROM Procedure_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OrderOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OrderOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProcedureTypeOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureTypeOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Index_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Index_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ScheduledStartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ScheduledStartTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PerformingFacilityOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PerformingFacilityOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Laterality_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Laterality_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Portable_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Portable_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProcedureCheckInOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureCheckInOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ImageAvailability_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImageAvailability_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DowntimeRecoveryMode_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DowntimeRecoveryMode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OrderOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OrderOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProcedureTypeOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureTypeOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Index_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Index_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScheduledStartTime_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScheduledStartTime_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ScheduledStartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ScheduledStartTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartTime_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartTime_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndTime_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndTime_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PerformingFacilityOID_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PerformingFacilityOID_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PerformingFacilityOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PerformingFacilityOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Laterality_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Laterality_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Portable_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Portable_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Portable_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Portable_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProcedureCheckInOID_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProcedureCheckInOID_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProcedureCheckInOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureCheckInOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImageAvailability_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImageAvailability_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ImageAvailability_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImageAvailability_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DowntimeRecoveryMode_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DowntimeRecoveryMode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="OrderOID_" DataSetColumn="OrderOID_" />
              <Mapping SourceColumn="ProcedureTypeOID_" DataSetColumn="ProcedureTypeOID_" />
              <Mapping SourceColumn="Index_" DataSetColumn="Index_" />
              <Mapping SourceColumn="ScheduledStartTime_" DataSetColumn="ScheduledStartTime_" />
              <Mapping SourceColumn="StartTime_" DataSetColumn="StartTime_" />
              <Mapping SourceColumn="EndTime_" DataSetColumn="EndTime_" />
              <Mapping SourceColumn="Status_" DataSetColumn="Status_" />
              <Mapping SourceColumn="PerformingFacilityOID_" DataSetColumn="PerformingFacilityOID_" />
              <Mapping SourceColumn="Laterality_" DataSetColumn="Laterality_" />
              <Mapping SourceColumn="Portable_" DataSetColumn="Portable_" />
              <Mapping SourceColumn="ProcedureCheckInOID_" DataSetColumn="ProcedureCheckInOID_" />
              <Mapping SourceColumn="ImageAvailability_" DataSetColumn="ImageAvailability_" />
              <Mapping SourceColumn="DowntimeRecoveryMode_" DataSetColumn="DowntimeRecoveryMode_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProcedureReport_TableAdapter" GeneratorDataComponentClassName="ProcedureReport_TableAdapter" Name="ProcedureReport_" UserDataComponentName="ProcedureReport_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.ProcedureReport_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ProcedureReport_] WHERE (([ProcedureOID_] = @Original_ProcedureOID_) AND ([ReportOID_] = @Original_ReportOID_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProcedureOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ReportOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ProcedureReport_] ([ProcedureOID_], [ReportOID_]) VALUES (@ProcedureOID_, @ReportOID_);
SELECT ProcedureOID_, ReportOID_ FROM ProcedureReport_ WHERE (ProcedureOID_ = @ProcedureOID_) AND (ReportOID_ = @ReportOID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProcedureOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ReportOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ProcedureOID_, ReportOID_ FROM dbo.ProcedureReport_ WHERE ProcedureOID_ = @procedureOID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="procedureOID" ColumnName="ProcedureOID_" DataSourceName="RIS.dbo.ProcedureReport_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@procedureOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ProcedureOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ProcedureReport_] SET [ProcedureOID_] = @ProcedureOID_, [ReportOID_] = @ReportOID_ WHERE (([ProcedureOID_] = @Original_ProcedureOID_) AND ([ReportOID_] = @Original_ReportOID_));
SELECT ProcedureOID_, ReportOID_ FROM ProcedureReport_ WHERE (ProcedureOID_ = @ProcedureOID_) AND (ReportOID_ = @ReportOID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProcedureOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ReportOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProcedureOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProcedureOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ReportOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProcedureOID_" DataSetColumn="ProcedureOID_" />
              <Mapping SourceColumn="ReportOID_" DataSetColumn="ReportOID_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Report_TableAdapter" GeneratorDataComponentClassName="Report_TableAdapter" Name="Report_" UserDataComponentName="Report_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.Report_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Report_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([Status_] = @Original_Status_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Report_] ([OID_], [Version_], [Status_]) VALUES (@OID_, @Version_, @Status_);
SELECT OID_, Version_, Status_ FROM Report_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OID_, Version_, Status_ FROM dbo.Report_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Report_] SET [OID_] = @OID_, [Version_] = @Version_, [Status_] = @Status_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([Status_] = @Original_Status_));
SELECT OID_, Version_, Status_ FROM Report_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="Status_" DataSetColumn="Status_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportPart_TableAdapter" GeneratorDataComponentClassName="ReportPart_TableAdapter" Name="ReportPart_" UserDataComponentName="ReportPart_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT RP.OID_, RP.Version_, Index_, RPS.Value_ AS Status_, CreationTime_, PreliminaryTime_, CompletedTime_, CancelledTime_, S.FamilyName_+' '+S.GivenName_ AS FullName, InterpreterOID_, TranscriberOID_, TranscriptionSupervisorOID_, VerifierOID_, TranscriptionRejectReason_, ReportOID_ 
FROM dbo.ReportPart_  RP, dbo.ReportPartStatusEnum_ RPS, Staff_ S
WHERE RP.Version_ = 1 AND  ReportOID_ = @reportOID AND 
RPS.Code_ = RP.Status_ AND
S.OID_ = RP.SupervisorOID_ AND RP.Status_&lt;&gt;'X' AND RP.Status_&lt;&gt;'I'
ORDER BY CreationTime_ DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="reportOID" ColumnName="ReportOID_" DataSourceName="RIS.dbo.ReportPart_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@reportOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ReportOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="Index_" DataSetColumn="Index_" />
              <Mapping SourceColumn="Status_" DataSetColumn="Status_" />
              <Mapping SourceColumn="CreationTime_" DataSetColumn="CreationTime_" />
              <Mapping SourceColumn="PreliminaryTime_" DataSetColumn="PreliminaryTime_" />
              <Mapping SourceColumn="CompletedTime_" DataSetColumn="CompletedTime_" />
              <Mapping SourceColumn="CancelledTime_" DataSetColumn="CancelledTime_" />
              <Mapping SourceColumn="InterpreterOID_" DataSetColumn="InterpreterOID_" />
              <Mapping SourceColumn="TranscriberOID_" DataSetColumn="TranscriberOID_" />
              <Mapping SourceColumn="TranscriptionSupervisorOID_" DataSetColumn="TranscriptionSupervisorOID_" />
              <Mapping SourceColumn="VerifierOID_" DataSetColumn="VerifierOID_" />
              <Mapping SourceColumn="TranscriptionRejectReason_" DataSetColumn="TranscriptionRejectReason_" />
              <Mapping SourceColumn="ReportOID_" DataSetColumn="ReportOID_" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportPartExtendedProperty_TableAdapter" GeneratorDataComponentClassName="ReportPartExtendedProperty_TableAdapter" Name="ReportPartExtendedProperty_" UserDataComponentName="ReportPartExtendedProperty_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.ReportPartExtendedProperty_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ReportPartExtendedProperty_] WHERE (([ReportPartOID_] = @Original_ReportPartOID_) AND ([Name_] = @Original_Name_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ReportPartOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportPartOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ReportPartExtendedProperty_] ([ReportPartOID_], [Value_], [Name_]) VALUES (@ReportPartOID_, @Value_, @Name_);
SELECT ReportPartOID_, Value_, Name_ FROM ReportPartExtendedProperty_ WHERE (Name_ = @Name_) AND (ReportPartOID_ = @ReportPartOID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ReportPartOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportPartOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReportPartOID_, Value_, Name_ FROM dbo.ReportPartExtendedProperty_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ReportPartExtendedProperty_] SET [ReportPartOID_] = @ReportPartOID_, [Value_] = @Value_, [Name_] = @Name_ WHERE (([ReportPartOID_] = @Original_ReportPartOID_) AND ([Name_] = @Original_Name_));
SELECT ReportPartOID_, Value_, Name_ FROM ReportPartExtendedProperty_ WHERE (Name_ = @Name_) AND (ReportPartOID_ = @ReportPartOID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ReportPartOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportPartOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ReportPartOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ReportPartOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReportPartOID_" DataSetColumn="ReportPartOID_" />
              <Mapping SourceColumn="Value_" DataSetColumn="Value_" />
              <Mapping SourceColumn="Name_" DataSetColumn="Name_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportPartStatusEnum_TableAdapter" GeneratorDataComponentClassName="ReportPartStatusEnum_TableAdapter" Name="ReportPartStatusEnum_" UserDataComponentName="ReportPartStatusEnum_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.ReportPartStatusEnum_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ReportPartStatusEnum_] WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ReportPartStatusEnum_] ([Code_], [Value_], [Description_], [DisplayOrder_], [Deactivated_]) VALUES (@Code_, @Value_, @Description_, @DisplayOrder_, @Deactivated_);
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM ReportPartStatusEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM dbo.ReportPartStatusEnum_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ReportPartStatusEnum_] SET [Code_] = @Code_, [Value_] = @Value_, [Description_] = @Description_, [DisplayOrder_] = @DisplayOrder_, [Deactivated_] = @Deactivated_ WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM ReportPartStatusEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code_" DataSetColumn="Code_" />
              <Mapping SourceColumn="Value_" DataSetColumn="Value_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="DisplayOrder_" DataSetColumn="DisplayOrder_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportStatusEnum_TableAdapter" GeneratorDataComponentClassName="ReportStatusEnum_TableAdapter" Name="ReportStatusEnum_" UserDataComponentName="ReportStatusEnum_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.ReportStatusEnum_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ReportStatusEnum_] WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ReportStatusEnum_] ([Code_], [Value_], [Description_], [DisplayOrder_], [Deactivated_]) VALUES (@Code_, @Value_, @Description_, @DisplayOrder_, @Deactivated_);
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM ReportStatusEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM dbo.ReportStatusEnum_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ReportStatusEnum_] SET [Code_] = @Code_, [Value_] = @Value_, [Description_] = @Description_, [DisplayOrder_] = @DisplayOrder_, [Deactivated_] = @Deactivated_ WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM ReportStatusEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code_" DataSetColumn="Code_" />
              <Mapping SourceColumn="Value_" DataSetColumn="Value_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="DisplayOrder_" DataSetColumn="DisplayOrder_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ReportDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ReportDataSet" msprop:Generator_UserDSName="ReportDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Procedure_" msprop:Generator_TableClassName="Procedure_DataTable" msprop:Generator_TableVarName="tableProcedure_" msprop:Generator_TablePropName="Procedure_" msprop:Generator_RowDeletingName="Procedure_RowDeleting" msprop:Generator_UserTableName="Procedure_" msprop:Generator_RowChangingName="Procedure_RowChanging" msprop:Generator_RowEvHandlerName="Procedure_RowChangeEventHandler" msprop:Generator_RowDeletedName="Procedure_RowDeleted" msprop:Generator_RowEvArgName="Procedure_RowChangeEvent" msprop:Generator_RowChangedName="Procedure_RowChanged" msprop:Generator_RowClassName="Procedure_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="OrderOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOrderOID_" msprop:Generator_ColumnPropNameInRow="OrderOID_" msprop:Generator_ColumnPropNameInTable="OrderOID_Column" msprop:Generator_UserColumnName="OrderOID_" type="xs:string" />
              <xs:element name="ProcedureTypeOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnProcedureTypeOID_" msprop:Generator_ColumnPropNameInRow="ProcedureTypeOID_" msprop:Generator_ColumnPropNameInTable="ProcedureTypeOID_Column" msprop:Generator_UserColumnName="ProcedureTypeOID_" type="xs:string" />
              <xs:element name="Index_" msprop:Generator_ColumnVarNameInTable="columnIndex_" msprop:Generator_ColumnPropNameInRow="Index_" msprop:Generator_ColumnPropNameInTable="Index_Column" msprop:Generator_UserColumnName="Index_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ScheduledStartTime_" msprop:Generator_ColumnVarNameInTable="columnScheduledStartTime_" msprop:Generator_ColumnPropNameInRow="ScheduledStartTime_" msprop:Generator_ColumnPropNameInTable="ScheduledStartTime_Column" msprop:Generator_UserColumnName="ScheduledStartTime_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="StartTime_" msprop:Generator_ColumnVarNameInTable="columnStartTime_" msprop:Generator_ColumnPropNameInRow="StartTime_" msprop:Generator_ColumnPropNameInTable="StartTime_Column" msprop:Generator_UserColumnName="StartTime_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndTime_" msprop:Generator_ColumnVarNameInTable="columnEndTime_" msprop:Generator_ColumnPropNameInRow="EndTime_" msprop:Generator_ColumnPropNameInTable="EndTime_Column" msprop:Generator_UserColumnName="EndTime_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Status_" msprop:Generator_ColumnVarNameInTable="columnStatus_" msprop:Generator_ColumnPropNameInRow="Status_" msprop:Generator_ColumnPropNameInTable="Status_Column" msprop:Generator_UserColumnName="Status_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PerformingFacilityOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPerformingFacilityOID_" msprop:Generator_ColumnPropNameInRow="PerformingFacilityOID_" msprop:Generator_ColumnPropNameInTable="PerformingFacilityOID_Column" msprop:Generator_UserColumnName="PerformingFacilityOID_" type="xs:string" minOccurs="0" />
              <xs:element name="Laterality_" msprop:Generator_ColumnVarNameInTable="columnLaterality_" msprop:Generator_ColumnPropNameInRow="Laterality_" msprop:Generator_ColumnPropNameInTable="Laterality_Column" msprop:Generator_UserColumnName="Laterality_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Portable_" msprop:Generator_ColumnVarNameInTable="columnPortable_" msprop:Generator_ColumnPropNameInRow="Portable_" msprop:Generator_ColumnPropNameInTable="Portable_Column" msprop:Generator_UserColumnName="Portable_" type="xs:boolean" minOccurs="0" />
              <xs:element name="ProcedureCheckInOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnProcedureCheckInOID_" msprop:Generator_ColumnPropNameInRow="ProcedureCheckInOID_" msprop:Generator_ColumnPropNameInTable="ProcedureCheckInOID_Column" msprop:Generator_UserColumnName="ProcedureCheckInOID_" type="xs:string" minOccurs="0" />
              <xs:element name="ImageAvailability_" msprop:Generator_ColumnVarNameInTable="columnImageAvailability_" msprop:Generator_ColumnPropNameInRow="ImageAvailability_" msprop:Generator_ColumnPropNameInTable="ImageAvailability_Column" msprop:Generator_UserColumnName="ImageAvailability_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DowntimeRecoveryMode_" msprop:Generator_ColumnVarNameInTable="columnDowntimeRecoveryMode_" msprop:Generator_ColumnPropNameInRow="DowntimeRecoveryMode_" msprop:Generator_ColumnPropNameInTable="DowntimeRecoveryMode_Column" msprop:Generator_UserColumnName="DowntimeRecoveryMode_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ProcedureReport_" msprop:Generator_TableClassName="ProcedureReport_DataTable" msprop:Generator_TableVarName="tableProcedureReport_" msprop:Generator_TablePropName="ProcedureReport_" msprop:Generator_RowDeletingName="ProcedureReport_RowDeleting" msprop:Generator_UserTableName="ProcedureReport_" msprop:Generator_RowChangingName="ProcedureReport_RowChanging" msprop:Generator_RowEvHandlerName="ProcedureReport_RowChangeEventHandler" msprop:Generator_RowDeletedName="ProcedureReport_RowDeleted" msprop:Generator_RowEvArgName="ProcedureReport_RowChangeEvent" msprop:Generator_RowChangedName="ProcedureReport_RowChanged" msprop:Generator_RowClassName="ProcedureReport_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProcedureOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnProcedureOID_" msprop:Generator_ColumnPropNameInRow="ProcedureOID_" msprop:Generator_ColumnPropNameInTable="ProcedureOID_Column" msprop:Generator_UserColumnName="ProcedureOID_" type="xs:string" />
              <xs:element name="ReportOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnReportOID_" msprop:Generator_ColumnPropNameInRow="ReportOID_" msprop:Generator_ColumnPropNameInTable="ReportOID_Column" msprop:Generator_UserColumnName="ReportOID_" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Report_" msprop:Generator_TableClassName="Report_DataTable" msprop:Generator_TableVarName="tableReport_" msprop:Generator_TablePropName="Report_" msprop:Generator_RowDeletingName="Report_RowDeleting" msprop:Generator_UserTableName="Report_" msprop:Generator_RowChangingName="Report_RowChanging" msprop:Generator_RowEvHandlerName="Report_RowChangeEventHandler" msprop:Generator_RowDeletedName="Report_RowDeleted" msprop:Generator_RowEvArgName="Report_RowChangeEvent" msprop:Generator_RowChangedName="Report_RowChanged" msprop:Generator_RowClassName="Report_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="Status_" msprop:Generator_ColumnVarNameInTable="columnStatus_" msprop:Generator_ColumnPropNameInRow="Status_" msprop:Generator_ColumnPropNameInTable="Status_Column" msprop:Generator_UserColumnName="Status_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReportPart_" msprop:Generator_TableClassName="ReportPart_DataTable" msprop:Generator_TableVarName="tableReportPart_" msprop:Generator_TablePropName="ReportPart_" msprop:Generator_RowDeletingName="ReportPart_RowDeleting" msprop:Generator_UserTableName="ReportPart_" msprop:Generator_RowChangingName="ReportPart_RowChanging" msprop:Generator_RowEvHandlerName="ReportPart_RowChangeEventHandler" msprop:Generator_RowDeletedName="ReportPart_RowDeleted" msprop:Generator_RowEvArgName="ReportPart_RowChangeEvent" msprop:Generator_RowChangedName="ReportPart_RowChanged" msprop:Generator_RowClassName="ReportPart_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="Index_" msprop:Generator_ColumnVarNameInTable="columnIndex_" msprop:Generator_ColumnPropNameInRow="Index_" msprop:Generator_ColumnPropNameInTable="Index_Column" msprop:Generator_UserColumnName="Index_" type="xs:int" />
              <xs:element name="Status_" msprop:Generator_ColumnVarNameInTable="columnStatus_" msprop:Generator_ColumnPropNameInRow="Status_" msprop:Generator_ColumnPropNameInTable="Status_Column" msprop:Generator_UserColumnName="Status_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreationTime_" msprop:Generator_ColumnVarNameInTable="columnCreationTime_" msprop:Generator_ColumnPropNameInRow="CreationTime_" msprop:Generator_ColumnPropNameInTable="CreationTime_Column" msprop:Generator_UserColumnName="CreationTime_" type="xs:dateTime" />
              <xs:element name="PreliminaryTime_" msprop:Generator_ColumnVarNameInTable="columnPreliminaryTime_" msprop:Generator_ColumnPropNameInRow="PreliminaryTime_" msprop:Generator_ColumnPropNameInTable="PreliminaryTime_Column" msprop:Generator_UserColumnName="PreliminaryTime_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CompletedTime_" msprop:Generator_ColumnVarNameInTable="columnCompletedTime_" msprop:Generator_ColumnPropNameInRow="CompletedTime_" msprop:Generator_ColumnPropNameInTable="CompletedTime_Column" msprop:Generator_UserColumnName="CompletedTime_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CancelledTime_" msprop:Generator_ColumnVarNameInTable="columnCancelledTime_" msprop:Generator_ColumnPropNameInRow="CancelledTime_" msprop:Generator_ColumnPropNameInTable="CancelledTime_Column" msprop:Generator_UserColumnName="CancelledTime_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="InterpreterOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnInterpreterOID_" msprop:Generator_ColumnPropNameInRow="InterpreterOID_" msprop:Generator_ColumnPropNameInTable="InterpreterOID_Column" msprop:Generator_UserColumnName="InterpreterOID_" type="xs:string" minOccurs="0" />
              <xs:element name="TranscriberOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnTranscriberOID_" msprop:Generator_ColumnPropNameInRow="TranscriberOID_" msprop:Generator_ColumnPropNameInTable="TranscriberOID_Column" msprop:Generator_UserColumnName="TranscriberOID_" type="xs:string" minOccurs="0" />
              <xs:element name="TranscriptionSupervisorOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnTranscriptionSupervisorOID_" msprop:Generator_ColumnPropNameInRow="TranscriptionSupervisorOID_" msprop:Generator_ColumnPropNameInTable="TranscriptionSupervisorOID_Column" msprop:Generator_UserColumnName="TranscriptionSupervisorOID_" type="xs:string" minOccurs="0" />
              <xs:element name="VerifierOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnVerifierOID_" msprop:Generator_ColumnPropNameInRow="VerifierOID_" msprop:Generator_ColumnPropNameInTable="VerifierOID_Column" msprop:Generator_UserColumnName="VerifierOID_" type="xs:string" minOccurs="0" />
              <xs:element name="TranscriptionRejectReason_" msprop:Generator_ColumnVarNameInTable="columnTranscriptionRejectReason_" msprop:Generator_ColumnPropNameInRow="TranscriptionRejectReason_" msprop:Generator_ColumnPropNameInTable="TranscriptionRejectReason_Column" msprop:Generator_UserColumnName="TranscriptionRejectReason_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReportOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnReportOID_" msprop:Generator_ColumnPropNameInRow="ReportOID_" msprop:Generator_ColumnPropNameInTable="ReportOID_Column" msprop:Generator_UserColumnName="ReportOID_" type="xs:string" />
              <xs:element name="FullName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="81" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReportPartExtendedProperty_" msprop:Generator_TableClassName="ReportPartExtendedProperty_DataTable" msprop:Generator_TableVarName="tableReportPartExtendedProperty_" msprop:Generator_TablePropName="ReportPartExtendedProperty_" msprop:Generator_RowDeletingName="ReportPartExtendedProperty_RowDeleting" msprop:Generator_UserTableName="ReportPartExtendedProperty_" msprop:Generator_RowChangingName="ReportPartExtendedProperty_RowChanging" msprop:Generator_RowEvHandlerName="ReportPartExtendedProperty_RowChangeEventHandler" msprop:Generator_RowDeletedName="ReportPartExtendedProperty_RowDeleted" msprop:Generator_RowEvArgName="ReportPartExtendedProperty_RowChangeEvent" msprop:Generator_RowChangedName="ReportPartExtendedProperty_RowChanged" msprop:Generator_RowClassName="ReportPartExtendedProperty_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReportPartOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnReportPartOID_" msprop:Generator_ColumnPropNameInRow="ReportPartOID_" msprop:Generator_ColumnPropNameInTable="ReportPartOID_Column" msprop:Generator_UserColumnName="ReportPartOID_" type="xs:string" />
              <xs:element name="Value_" msprop:Generator_ColumnVarNameInTable="columnValue_" msprop:Generator_ColumnPropNameInRow="Value_" msprop:Generator_ColumnPropNameInTable="Value_Column" msprop:Generator_UserColumnName="Value_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name_" msprop:Generator_ColumnVarNameInTable="columnName_" msprop:Generator_ColumnPropNameInRow="Name_" msprop:Generator_ColumnPropNameInTable="Name_Column" msprop:Generator_UserColumnName="Name_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReportPartStatusEnum_" msprop:Generator_TableClassName="ReportPartStatusEnum_DataTable" msprop:Generator_TableVarName="tableReportPartStatusEnum_" msprop:Generator_TablePropName="ReportPartStatusEnum_" msprop:Generator_RowDeletingName="ReportPartStatusEnum_RowDeleting" msprop:Generator_UserTableName="ReportPartStatusEnum_" msprop:Generator_RowChangingName="ReportPartStatusEnum_RowChanging" msprop:Generator_RowEvHandlerName="ReportPartStatusEnum_RowChangeEventHandler" msprop:Generator_RowDeletedName="ReportPartStatusEnum_RowDeleted" msprop:Generator_RowEvArgName="ReportPartStatusEnum_RowChangeEvent" msprop:Generator_RowChangedName="ReportPartStatusEnum_RowChanged" msprop:Generator_RowClassName="ReportPartStatusEnum_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code_" msprop:Generator_ColumnVarNameInTable="columnCode_" msprop:Generator_ColumnPropNameInRow="Code_" msprop:Generator_ColumnPropNameInTable="Code_Column" msprop:Generator_UserColumnName="Code_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value_" msprop:Generator_ColumnVarNameInTable="columnValue_" msprop:Generator_ColumnPropNameInRow="Value_" msprop:Generator_ColumnPropNameInTable="Value_Column" msprop:Generator_UserColumnName="Value_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder_" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder_" msprop:Generator_ColumnPropNameInRow="DisplayOrder_" msprop:Generator_ColumnPropNameInTable="DisplayOrder_Column" msprop:Generator_UserColumnName="DisplayOrder_" type="xs:float" minOccurs="0" />
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReportStatusEnum_" msprop:Generator_TableClassName="ReportStatusEnum_DataTable" msprop:Generator_TableVarName="tableReportStatusEnum_" msprop:Generator_TablePropName="ReportStatusEnum_" msprop:Generator_RowDeletingName="ReportStatusEnum_RowDeleting" msprop:Generator_UserTableName="ReportStatusEnum_" msprop:Generator_RowChangingName="ReportStatusEnum_RowChanging" msprop:Generator_RowEvHandlerName="ReportStatusEnum_RowChangeEventHandler" msprop:Generator_RowDeletedName="ReportStatusEnum_RowDeleted" msprop:Generator_RowEvArgName="ReportStatusEnum_RowChangeEvent" msprop:Generator_RowChangedName="ReportStatusEnum_RowChanged" msprop:Generator_RowClassName="ReportStatusEnum_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code_" msprop:Generator_ColumnVarNameInTable="columnCode_" msprop:Generator_ColumnPropNameInRow="Code_" msprop:Generator_ColumnPropNameInTable="Code_Column" msprop:Generator_UserColumnName="Code_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value_" msprop:Generator_ColumnVarNameInTable="columnValue_" msprop:Generator_ColumnPropNameInRow="Value_" msprop:Generator_ColumnPropNameInTable="Value_Column" msprop:Generator_UserColumnName="Value_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder_" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder_" msprop:Generator_ColumnPropNameInRow="DisplayOrder_" msprop:Generator_ColumnPropNameInTable="DisplayOrder_Column" msprop:Generator_UserColumnName="DisplayOrder_" type="xs:float" minOccurs="0" />
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Procedure_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="ProcedureReport__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProcedureReport_" />
      <xs:field xpath="mstns:ProcedureOID_" />
      <xs:field xpath="mstns:ReportOID_" />
    </xs:unique>
    <xs:unique name="Report__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Report_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="ReportPart__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReportPart_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="ReportPartExtendedProperty__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReportPartExtendedProperty_" />
      <xs:field xpath="mstns:ReportPartOID_" />
      <xs:field xpath="mstns:Name_" />
    </xs:unique>
    <xs:unique name="ReportPartStatusEnum__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReportPartStatusEnum_" />
      <xs:field xpath="mstns:Code_" />
    </xs:unique>
    <xs:unique name="ReportStatusEnum__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReportStatusEnum_" />
      <xs:field xpath="mstns:Code_" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ProcedureOID_CEE158F2E91D2D6D76D44EAB9AD0A89B" msdata:parent="Procedure_" msdata:child="ProcedureReport_" msdata:parentkey="OID_" msdata:childkey="ProcedureOID_" msprop:Generator_UserChildTable="ProcedureReport_" msprop:Generator_ChildPropName="GetProcedureReport_Rows" msprop:Generator_ParentPropName="Procedure_Row" msprop:Generator_UserRelationName="FK_ProcedureOID_CEE158F2E91D2D6D76D44EAB9AD0A89B" msprop:Generator_RelationVarName="relationFK_ProcedureOID_CEE158F2E91D2D6D76D44EAB9AD0A89B" msprop:Generator_UserParentTable="Procedure_" />
      <msdata:Relationship name="FK_ReportOID_3B82211EEEF7A278EA6380144A38F29B" msdata:parent="Report_" msdata:child="ProcedureReport_" msdata:parentkey="OID_" msdata:childkey="ReportOID_" msprop:Generator_UserChildTable="ProcedureReport_" msprop:Generator_ChildPropName="GetProcedureReport_Rows" msprop:Generator_ParentPropName="Report_Row" msprop:Generator_UserRelationName="FK_ReportOID_3B82211EEEF7A278EA6380144A38F29B" msprop:Generator_RelationVarName="relationFK_ReportOID_3B82211EEEF7A278EA6380144A38F29B" msprop:Generator_UserParentTable="Report_" />
      <msdata:Relationship name="FK_Status_EF8C2325366FF06611B4CDC922F0BE60" msdata:parent="ReportStatusEnum_" msdata:child="Report_" msdata:parentkey="Code_" msdata:childkey="Status_" msprop:Generator_UserChildTable="Report_" msprop:Generator_ChildPropName="GetReport_Rows" msprop:Generator_ParentPropName="ReportStatusEnum_Row" msprop:Generator_UserRelationName="FK_Status_EF8C2325366FF06611B4CDC922F0BE60" msprop:Generator_RelationVarName="relationFK_Status_EF8C2325366FF06611B4CDC922F0BE60" msprop:Generator_UserParentTable="ReportStatusEnum_" />
      <msdata:Relationship name="FK_ReportOID_6BFCEF389969559943EBE60A98047932" msdata:parent="Report_" msdata:child="ReportPart_" msdata:parentkey="OID_" msdata:childkey="ReportOID_" msprop:Generator_UserChildTable="ReportPart_" msprop:Generator_ChildPropName="GetReportPart_Rows" msprop:Generator_ParentPropName="Report_Row" msprop:Generator_UserRelationName="FK_ReportOID_6BFCEF389969559943EBE60A98047932" msprop:Generator_RelationVarName="relationFK_ReportOID_6BFCEF389969559943EBE60A98047932" msprop:Generator_UserParentTable="Report_" />
      <msdata:Relationship name="FK_Status_0AC3893DF054F8B7C1B8DCF1EC246A17" msdata:parent="ReportPartStatusEnum_" msdata:child="ReportPart_" msdata:parentkey="Code_" msdata:childkey="Status_" msprop:Generator_UserChildTable="ReportPart_" msprop:Generator_ChildPropName="GetReportPart_Rows" msprop:Generator_ParentPropName="ReportPartStatusEnum_Row" msprop:Generator_UserRelationName="FK_Status_0AC3893DF054F8B7C1B8DCF1EC246A17" msprop:Generator_RelationVarName="relationFK_Status_0AC3893DF054F8B7C1B8DCF1EC246A17" msprop:Generator_UserParentTable="ReportPartStatusEnum_" />
      <msdata:Relationship name="FK_ReportPartOID_BED593B39BEA6775616B3376F2E43305" msdata:parent="ReportPart_" msdata:child="ReportPartExtendedProperty_" msdata:parentkey="OID_" msdata:childkey="ReportPartOID_" msprop:Generator_UserChildTable="ReportPartExtendedProperty_" msprop:Generator_ChildPropName="GetReportPartExtendedProperty_Rows" msprop:Generator_ParentPropName="ReportPart_Row" msprop:Generator_UserRelationName="FK_ReportPartOID_BED593B39BEA6775616B3376F2E43305" msprop:Generator_RelationVarName="relationFK_ReportPartOID_BED593B39BEA6775616B3376F2E43305" msprop:Generator_UserParentTable="ReportPart_" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>